This repository contains code to visualize employee salary data from the Government of Canada’s Treasury Board, publicly available here. A webpage with outputs and findings can be found here.
This data is based on self-identification of equity-deserving group
and is only available for the core federal public service. In order to
obtain the data, the webpage was scraped with the R package
rvest. Then, dplyr and tidyr were
used to clean it up and plotting was done with: ggplot2,
plotly scales, and MetBrewer.
We are including the following groups in
Total Asian Population:
Non-White West Asian was not included because it was grouped along with North African and Arab. If needed, this group can be added into the data.
This plot looks at the total count of self-identifying Asian employees.
This plot looks at the year-over-year (YOY) growth of self-identifying Asian employees.
Considering these two plots, we can see that though the YOY is comparable between Asian and non-Asian employees, the pre-existing disproportionality between the groups continue to persist.
This is a more focused plot which looks at the top 10 deparments with the highest Asian population.
This is a really busy plot but it shows the breakdown of Asian and non-Asian employees by count.
Moving forward, these data can be further broken down looking more into the departments/agencies, looking at the classfication, salary wages, etc.